package cn.gson.fengboot.model.dao;

import cn.gson.fengboot.model.pojos.Lshenpi;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

public interface LshenpiDao extends CrudRepository<Lshenpi,Integer> {
    //统计图类型分布查询
    @Query(nativeQuery = true,value = "update lshenpi set sp_spzt=?1,emp_id=?2,sp_shenqindate=?3 where sp_id=?4")
    public void xgsp(String spzt, Integer empid, String date, String spid);


}
